* OPEN STATA OUTPUT FILE LOG

   log using "K:\Melusky\concentrated powers.05-16-11.JOP.smcl" 




 * OPEN "COLLECTIVE WISDOM" DATA SET
  
    use "K:\Melusky\concentrated powers.05-16-11.JOP.dta", clear
  



************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

*** SET TIME SERIES - CROSS SECTION IDENTIFER ***

tsset state_code fiscal_year, yearly
*
*
xtsum  pctchrealpcgenexpend  l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.uerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  bindingforecast  dividedgov balbudrestriction termlimlameduck govelection ecpartial ecfull govbudfull govforepower govbudfullgfp l1.statenatdiffuerate citizenideology legpartisan vetooverridemajority govitemveto if  xtregfull!=.

*
*
*
*

summarize  pctchrealpcgenexpend if xtregfull!=. , detail


*
*
*
*
*
*
*
*
*
*
*
*


***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************



* AGGREGATE MODEL ANALYSIS *



tabulate ecpartial if xtregfull!=.
* 
tabulate ecfull if xtregfull!=.
*
*
*
tabulate govbudfull if xtregfull!=.
*
tabulate govforepower if xtregfull!=.
*
tabulate govbudfullgfp if xtregfull!=.




*** DISAGGREGATED BY PARTISAN (DEMOCRATIC VERSUS REPUBLICAN) GOVERNORS) [TABLE 2] ***


tabulate ecpartial if govparty==1 & xtregfull!=.
*
tabulate ecpartial if govparty==-1 & xtregfull!=.
*
*
tabulate ecfull if govparty==1 & xtregfull!=.
*
tabulate ecfull if govparty==-1 & xtregfull!=.
*
*
tabulate govbudfull if govparty==1 & xtregfull!=.
*
tabulate govbudfull if govparty==-1 & xtregfull!=.
*
*
tabulate govforepower if govparty==1 & xtregfull!=. 
*
tabulate govforepower if govparty==-1 & xtregfull!=.
*
*
tabulate govbudfullgfp if govparty==1 & xtregfull!=.
*
tabulate govbudfullgfp if govparty==-1 & xtregfull!=. 




***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************





**** DESCRIPTIVE STATISTICS: ALL OBSERVATIONS (N*T = 1050)

xtsum pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  ecpartial ecfull bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if xtregfull!=.



**** DESCRIPTIVE STATISTICS: DEMOCRATIC GOVERNORS ONLY (N*T = 490)

xtsum pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  ecpartial ecfull bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if govparty==1 & xtregfull!=.



**** DESCRIPTIVE STATISTICS: REPUBLICAN GOVERNORS ONLY (N*T = 540)

xtsum pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  ecpartial ecfull bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if govparty==-1 & xtregfull!=.







***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************




********* II.A AGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE 1 - MODEL 1 (ECPARTIAL, ECFULL: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY) **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  ecpartial ecfull bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto, fe cluster(state_code)

estat ic 

*

test ecpartial = ecfull

*
*
*
*
*

*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- ABSENCE OF UNILATERAL EXECUTIVE FISCAL POLICY CONTROL -- GIVEN ECPARTIAL = 0, ECFULL = 0; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons + 1.909286*l1.pctchrealpercapincome + 3.038438*l1.pctchrealpercapfedaid + -0.2257*l1.statenatdiffuerate + 0.4038095*bienniel + -0.047619*govparty + 0.2309971*pctsalestaxrev + 1.75103*econgrowthvolatility + 23765.34*real_leg__salary__avg_  +  0.5088265*pctscorefixed  + 0*ecpartial + 0*ecfull + 0.4142857*bindingforecast + 0.2705*termlimlameduck + 0.25238*govelection + 0.5933*dividedgov  + 0.5628571*balbudrestriction + 49.9289*citizenideology  + 0.136*legpartisan + 0.135*vetooverridemajority + 0.852381*govitemveto 

*
*
*
*
*
*


*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- PARTIAL UNILATERAL EXECUTIVE FISCAL POLICY CONTROL  -- ECPARTIAL = 1, ECFULL = 0; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons + 1.909286*l1.pctchrealpercapincome + 3.038438*l1.pctchrealpercapfedaid  + -0.2257*l1.statenatdiffuerate + 0.4038095*bienniel + -0.047619*govparty + 0.2309971*pctsalestaxrev + 1.75103*econgrowthvolatility + 23765.34*real_leg__salary__avg_  + 0.5088265*pctscorefixed  + 1*ecpartial + 0*ecfull + 0.4142857*bindingforecast + 0.2705*termlimlameduck + 0.25238*govelection + 0.5933*dividedgov + 0.5628571*balbudrestriction + 49.9289*citizenideology +  0.136*legpartisan + 0.135*vetooverridemajority + 0.852381*govitemveto 


*
*
*
*
*
*


*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- FULL UNILATERAL EXECUTIVE FISCAL POLICY CONTROL  -- ECPARTIAL = 0, ECFULL = 1; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons + 1.909286*l1.pctchrealpercapincome + 3.038438*l1.pctchrealpercapfedaid  + -0.2257*l1.statenatdiffuerate + 0.4038095*bienniel + -0.047619*govparty + 0.2309971*pctsalestaxrev + 1.75103*econgrowthvolatility + 23765.34*real_leg__salary__avg_  + 0.5088265*pctscorefixed  + 0*ecpartial + 1*ecfull + 0.4142857*bindingforecast + 0.2705*termlimlameduck + 0.25238*govelection + 0.5933*dividedgov + 0.5628571*balbudrestriction + 49.9289*citizenideology + 0.136*legpartisan + 0.135*vetooverridemajority + 0.852381*govitemveto 

*
*
*



***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************



********* II.B  AGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE 1 - MODEL 2 (ECPARTIAL, ECFULL: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY)  **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  ecpartial ecfull bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if pctchrealpcgenexpend>=-8.247863 & pctchrealpcgenexpend<=14.71839, fe cluster(state_code)

estat ic 

*

test ecpartial = ecfull





***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************




********* III.A  DISAGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE 1 -  MODEL 3 (GOVBUDFULL, GOVFOREPOWER, GOVBUDFULLGFP: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY) **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  govbudfull govforepower govbudfullgfp bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto, fe cluster(state_code)

estat ic 

*

test govbudfull = govforepower



*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- ABSENCE OF UNILATERAL EXECUTIVE FISCAL POLICY CONTROL -- GIVEN GOVBUDFULL = 0, GOVFOREPOWER = 0, GOVBUDFULLGFP = 0; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons + 1.909286*l1.pctchrealpercapincome + 3.038438*l1.pctchrealpercapfedaid + -0.2257*l1.statenatdiffuerate + 0.4038095*bienniel + -0.047619*govparty + 0.2309971*pctsalestaxrev + 1.75103*econgrowthvolatility + 23765.34*real_leg__salary__avg_  +  0.5088265*pctscorefixed  + 0*govbudfull + 0*govforepower + 0*govbudfullgfp + 0.4142857*bindingforecast + 0.2705*termlimlameduck + 0.25238*govelection + 0.5933*dividedgov  + 0.5628571*balbudrestriction + 49.9289*citizenideology  + 0.136*legpartisan + 0.135*vetooverridemajority + 0.852381*govitemveto 

*
*
*
*
*
*


*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- PARTIAL UNILATERAL EXECUTIVE FISCAL POLICY CONTROL [BUDGET CONTROL]  -- GIVEN GOVBUDFULL = 1, GOVFOREPOWER = 0, GOVBUDFULLGFP = 0; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons + 1.909286*l1.pctchrealpercapincome + 3.038438*l1.pctchrealpercapfedaid  + -0.2257*l1.statenatdiffuerate + 0.4038095*bienniel + -0.047619*govparty + 0.2309971*pctsalestaxrev + 1.75103*econgrowthvolatility + 23765.34*real_leg__salary__avg_  + 0.5088265*pctscorefixed  + 1*govbudfull + 0*govforepower + 0*govbudfullgfp + 0.4142857*bindingforecast + 0.2705*termlimlameduck + 0.25238*govelection + 0.5933*dividedgov + 0.5628571*balbudrestriction + 49.9289*citizenideology +  0.136*legpartisan + 0.135*vetooverridemajority + 0.852381*govitemveto 


*
*
*
*
*
*


*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- PARTIAL UNILATERAL EXECUTIVE FISCAL POLICY CONTROL  [REVENUE FORECAST CONTROL] -- GIVEN GOVBUDFULL = 0, GOVFOREPOWER = 1, GOVBUDFULLGFP = 0; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons + 1.909286*l1.pctchrealpercapincome + 3.038438*l1.pctchrealpercapfedaid  + -0.2257*l1.statenatdiffuerate + 0.4038095*bienniel + -0.047619*govparty + 0.2309971*pctsalestaxrev + 1.75103*econgrowthvolatility + 23765.34*real_leg__salary__avg_  + 0.5088265*pctscorefixed  + 0*govbudfull + 1*govforepower + 0*govbudfullgfp + 0.4142857*bindingforecast + 0.2705*termlimlameduck + 0.25238*govelection + 0.5933*dividedgov + 0.5628571*balbudrestriction + 49.9289*citizenideology + 0.136*legpartisan + 0.135*vetooverridemajority + 0.852381*govitemveto 

*
*
*

*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- FULL UNILATERAL EXECUTIVE FISCAL POLICY CONTROL  [BOTH BUDGET & REVENUE FORECAST CONTROL] -- GIVEN GOVBUDFULL = 0, GOVFOREPOWER = 0, GOVBUDFULLGFP = 1; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons + 1.909286*l1.pctchrealpercapincome + 3.038438*l1.pctchrealpercapfedaid  + -0.2257*l1.statenatdiffuerate + 0.4038095*bienniel + -0.047619*govparty + 0.2309971*pctsalestaxrev + 1.75103*econgrowthvolatility + 23765.34*real_leg__salary__avg_  + 0.5088265*pctscorefixed  + 0*govbudfull + 0*govforepower + 1*govbudfullgfp + 0.4142857*bindingforecast + 0.2705*termlimlameduck + 0.25238*govelection + 0.5933*dividedgov + 0.5628571*balbudrestriction + 49.9289*citizenideology + 0.136*legpartisan + 0.135*vetooverridemajority + 0.852381*govitemveto 

*
*
*





***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************



********* III.B  AGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE 1 - MODEL 4 (GOVBUDFULL, GOVFOREPOWER, GOVBUDFULLGFP: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY) **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  govbudfull govforepower govbudfullgfp bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if pctchrealpcgenexpend>=-8.247863 & pctchrealpcgenexpend<=14.71839, fe cluster(state_code)

estat ic 

*

test govbudfull = govforepower



**************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************







********* IV.A  AGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE 2 - MODEL 5 (ECPARTIAL, ECFULL: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY FOR DEMOCRATIC GOVERNORS ONLY) **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  ecpartial ecfull bindingforecast termlimlameduck govelection  dividedgov citizenideology legpartisan vetooverridemajority govitemveto if govparty==1, fe cluster(state_code)

estat ic 

*

test ecpartial = ecfull

*
*
*
*
*

*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- ABSENCE OF UNILATERAL EXECUTIVE FISCAL POLICY CONTROL -- GIVEN ECPARTIAL = 0, ECFULL = 0; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons + 1.869805*l1.pctchrealpercapincome +  3.32769*l1.pctchrealpercapfedaid + -0.1471599*l1.statenatdiffuerate + 0.4204082*bienniel + 0.2244029 *pctsalestaxrev + 1.709503*econgrowthvolatility +  23719.85*real_leg__salary__avg_  +  0.4999596 *pctscorefixed  + 0*ecpartial + 0*ecfull + 0.4612245*bindingforecast + 0.277551*termlimlameduck + 0.2530612*govelection + 0.5306122*dividedgov  +  50.82935*citizenideology  + 0.255102*legpartisan +  0.0938776*vetooverridemajority +  0.8530612*govitemveto 

*
*
*
*
*
*


*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- PARTIAL UNILATERAL EXECUTIVE FISCAL POLICY CONTROL  -- ECPARTIAL = 1, ECFULL = 0; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons + 1.869805*l1.pctchrealpercapincome +  3.32769*l1.pctchrealpercapfedaid + -0.1471599*l1.statenatdiffuerate + 0.4204082*bienniel + 0.2244029 *pctsalestaxrev + 1.709503*econgrowthvolatility +  23719.85*real_leg__salary__avg_  +  0.4999596 *pctscorefixed  + 1*ecpartial + 0*ecfull + 0.4612245*bindingforecast + 0.277551*termlimlameduck + 0.2530612*govelection + 0.5306122*dividedgov  +  50.82935*citizenideology  + 0.255102*legpartisan +  0.0938776*vetooverridemajority +  0.8530612*govitemveto 


*
*
*
*
*
*


*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- FULL UNILATERAL EXECUTIVE FISCAL POLICY CONTROL  -- ECPARTIAL = 0, ECFULL = 1; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons + 1.869805*l1.pctchrealpercapincome +  3.32769*l1.pctchrealpercapfedaid + -0.1471599*l1.statenatdiffuerate + 0.4204082*bienniel + 0.2244029 *pctsalestaxrev + 1.709503*econgrowthvolatility +  23719.85*real_leg__salary__avg_  +  0.4999596 *pctscorefixed  + 0*ecpartial + 1*ecfull + 0.4612245*bindingforecast + 0.277551*termlimlameduck + 0.2530612*govelection + 0.5306122*dividedgov  +  50.82935*citizenideology  + 0.255102*legpartisan +  0.0938776*vetooverridemajority +  0.8530612*govitemveto 

*
*
*

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************


********* IV.B  AGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE 2 - MODEL 6 (ECPARTIAL, ECFULL: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY FOR DEMOCRATIC GOVERNORS ONLY) **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  ecpartial ecfull  bindingforecast termlimlameduck govelection  dividedgov citizenideology legpartisan vetooverridemajority govitemveto if govparty==1 & pctchrealpcgenexpend>=-8.247863 & pctchrealpcgenexpend<=14.71839, fe cluster(state_code)

estat ic 

*

test ecpartial = ecfull






***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************




********* V.A  AGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE 2 - MODEL 7  (ECPARTIAL, ECFULL: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY FOR REPUBLICAN GOVERNORS ONLY)  **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  ecpartial ecfull bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if govparty==-1, fe cluster(state_code)

estat ic 

*

test ecpartial = ecfull

*
*
*
*
*

*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- ABSENCE OF UNILATERAL EXECUTIVE FISCAL POLICY CONTROL -- GIVEN ECPARTIAL = 0, ECFULL = 0; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons +  1.925318*l1.pctchrealpercapincome +  2.722544*l1.pctchrealpercapfedaid + -0.2659877*l1.statenatdiffuerate + 0.3740741*bienniel  + 0.2384933*pctsalestaxrev + 1.78264*econgrowthvolatility + 23905.11*real_leg__salary__avg_  +  0.5255842*pctscorefixed  + 0*ecpartial + 0*ecfull + 0.3648148*bindingforecast + 0.2666667*termlimlameduck + 0.2518519*govelection +  0.6351852*dividedgov  +  0.5611111*balbudrestriction +  48.8617*citizenideology  + 0.0481481*legpartisan + 0.1592593*vetooverridemajority +  0.8611111*govitemveto 

*
*
*
*
*
*


*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- PARTIAL UNILATERAL EXECUTIVE FISCAL POLICY CONTROL  -- ECPARTIAL = 1, ECFULL = 0; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons +  1.925318*l1.pctchrealpercapincome +  2.722544*l1.pctchrealpercapfedaid + -0.2659877*l1.statenatdiffuerate + 0.3740741*bienniel  + 0.2384933*pctsalestaxrev + 1.78264*econgrowthvolatility + 23905.11*real_leg__salary__avg_  +  0.5255842*pctscorefixed  + 1*ecpartial + 0*ecfull + 0.3648148*bindingforecast + 0.2666667*termlimlameduck + 0.2518519*govelection +  0.6351852*dividedgov  +  0.5611111*balbudrestriction +  48.8617*citizenideology  + 0.0481481*legpartisan + 0.1592593*vetooverridemajority +  0.8611111*govitemveto 


*
*
*
*
*
*


*** COMPUTE SIMULATED VALUES OF THE DEPENDENT VARIABLE (PCTCHREALPCGENEXPEND) -- FULL UNILATERAL EXECUTIVE FISCAL POLICY CONTROL  -- ECPARTIAL = 0, ECFULL = 1; ALL OTHER VARIABLES EVALUATED AT THEIR MEAN) *** 

lincom _cons +  1.925318*l1.pctchrealpercapincome +  2.722544*l1.pctchrealpercapfedaid + -0.2659877*l1.statenatdiffuerate + 0.3740741*bienniel  + 0.2384933*pctsalestaxrev + 1.78264*econgrowthvolatility + 23905.11*real_leg__salary__avg_  +  0.5255842*pctscorefixed  + 0*ecpartial + 1*ecfull + 0.3648148*bindingforecast + 0.2666667*termlimlameduck + 0.2518519*govelection +  0.6351852*dividedgov  +  0.5611111*balbudrestriction +  48.8617*citizenideology  + 0.0481481*legpartisan + 0.1592593*vetooverridemajority +  0.8611111*govitemveto 

*
*
*


***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************



********* V.B  AGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE 2 - MODEL 8 (ECPARTIAL, ECFULL: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY FOR REPUBLICAN GOVERNORS ONLY)  **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  ecpartial ecfull  bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if govparty==-1 & pctchrealpcgenexpend>=-8.247863 & pctchrealpcgenexpend<=14.71839, fe cluster(state_code)

estat ic 

*

test ecpartial = ecfull






***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

**************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************










********* VI.A  DISAGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE SA-4 - MODEL SA-1 (GOVBUDFULL, GOVFOREPOWER, GOVBUDFULLGFP: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY FOR DEMOCRATIC GOVERNORS ONLY)  **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  govbudfull govforepower govbudfullgfp bindingforecast termlimlameduck govelection  dividedgov  citizenideology legpartisan vetooverridemajority govitemveto if govparty==1, fe cluster(state_code)

estat ic 

*

test govbudfull = govforepower

*
*
*





***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************



********* VI.B  DISAGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE SA-4 - MODEL SA-2 (GOVBUDFULL, GOVFOREPOWER, GOVBUDFULLGFP: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY FOR DEMOCRATIC GOVERNORS ONLY)  **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  govbudfull govforepower govbudfullgfp bindingforecast termlimlameduck govelection  dividedgov  citizenideology legpartisan vetooverridemajority govitemveto if govparty==1 & pctchrealpcgenexpend>=-8.247863 & pctchrealpcgenexpend<=14.71839, fe cluster(state_code)

estat ic 

*

test govbudfull = govforepower

*
*
*


***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

**************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************





********* VII.A  DISAGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE SA-4 - MODEL SA-3 (GOVBUDFULL, GOVFOREPOWER, GOVBUDFULLGFP: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY FOR REPUBLICAN GOVERNORS ONLY) **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel  pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  govbudfull govforepower govbudfullgfp bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if govparty==-1, fe cluster(state_code)

estat ic 

*

test govbudfull = govforepower

*
*
*




***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************



********* VII.B  DISAGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE SA-4 - MODEL SA-4 (GOVBUDFULL, GOVFOREPOWER, GOVBUDFULLGFP: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY FOR REPUBLICAN GOVERNORS ONLY) **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel  pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  govbudfull govforepower govbudfullgfp bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if govparty==-1 & pctchrealpcgenexpend>=-8.247863 & pctchrealpcgenexpend<=14.71839, fe cluster(state_code)


estat ic 

*

test govbudfull = govforepower

*
*
*






*************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************






*** DISAGGREGATED BY PARTISAN (DEMOCRATIC OR REPUBLICAN) GOVERNORS - EXCLUDING THIRD PARTY/INDEPENDENT GOVERNORS) [SUPPLEMENTARY TABLE SA-5] ***


tabulate ecpartial if govparty==1 | govparty==-1 & xtregfull!=.
*
*
tabulate ecfull if govparty==1 | govparty==-1 & xtregfull!=.
*
*
tabulate govbudfull if govparty==1 | govparty==-1 & xtregfull!=.
*
*
tabulate govforepower if govparty==1 | govparty==-1 & xtregfull!=.
*
*
tabulate govbudfullgfp if govparty==1 | govparty==-1 & xtregfull!=.




***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************




********* VIII.A  AGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE SA-5 - MODEL 1 (ECPARTIAL, ECFULL: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY FOR DEMOCRATIC AND REPUBLICAN GOVERNORS ONLY) **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  ecpartial ecfull bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if govparty==1 | govparty==-1, fe cluster(state_code)

estat ic 

*

test ecpartial = ecfull

*
*
*
*
*


***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************





********* VIII.B  DISAGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE SA-5 - MODEL 2 (GOVBUDFULL, GOVFOREPOWER, GOVBUDFULLGFP: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY FOR DEMOCRATIC AND REPUBLICAN GOVERNORS ONLY)  **************



*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_   pctscorefixed  govbudfull govforepower govbudfullgfp bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto if govparty==1 | govparty==-1, fe cluster(state_code)

estat ic 

*

test govbudfull = govforepower







***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************








*** ASSESSING CONDITIONAL UNILATERAL EXECUTIVE FISCAL CONTROL EFFECTS (TERM LIMITED LAME-DUCK GOVERNOR; GUBERNATORIAL ELECTION YEAR; DUAL BALANCED BUDGET RESTRICTIONS; 'CORRECTED' FISCAL TRAMSPARENCY SCORE/INDEX; DIVIDED PARTY GOVERNMENT) [SUPPLEMENTARY TABLE SA-6] ***


*
*
*
*
*

tabulate ecpartiallameduck if xtregfull!=.
*
tabulate ecpartialgovelection  if xtregfull!=.
*
tabulate ecpartialbalbudrestrict  if xtregfull!=.
*
tabulate ecpartialpctscore  if xtregfull!=.
*
tabulate ecpartialdividedgov if xtregfull!=.

*
*
*

tabulate ecfulllameduck if xtregfull!=.
*
tabulate ecfullgovelection  if xtregfull!=.
*
tabulate ecfullbalbudrestrict  if xtregfull!=.
*
tabulate ecfullpctscore  if xtregfull!=.
*
tabulate ecfulldividedgov if xtregfull!=.

*
*
*
*
*
*
*
*
*
*

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************




********* IX.A  AGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE SA-6 - MODEL 1 (ECPARTIAL, ECFULL: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY --- CONDITIONAL ON VARIOUS RELEVANT EFFECTS)  **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_  pctscorefixed  ecpartial ecfull bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto ecpartiallameduck ecpartialgovelection ecpartialbalbudrestrict ecpartialpctscorefixed ecpartialdividedgov ecfulllameduck ecfullgovelection ecfullbalbudrestrict ecfullpctscorefixed ecfulldividedgov, fe cluster(state_code)

estat ic 

*

*
*
*
*
*
*
*
*



***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************




********* IX.B  AGGREGATE ANALYSIS OF EXECUTIVE CAPACITY: TABLE SA-6 - MODEL 2 (ECPARTIAL, ECFULL: GOVERNOR HAS FULL AUTHORITY IN BUDGET PREPARATION AND/OR OFFICIAL REVENUE FORECAST AUTHORITY --- CONDITIONAL ON VARIOUS RELEVANT EFFECTS)  **************


*** SET TIME SERIES - CROSS SECTION IDENTIFER ***
 
 
tsset state_code fiscal_year, yearly


xtreg  pctchrealpcgenexpend l1.pctchrealpercapincome l1.pctchrealpercapfedaid  l1.statenatdiffuerate  bienniel govparty pctsalestaxrev  econgrowthvolatility  real_leg__salary__avg_  pctscorefixed  ecpartial ecfull bindingforecast termlimlameduck govelection  dividedgov balbudrestriction citizenideology legpartisan vetooverridemajority govitemveto ecpartiallameduck ecpartialgovelection ecpartialbalbudrestrict ecpartialpctscorefixed ecpartialdividedgov ecfulllameduck ecfullgovelection ecfullbalbudrestrict ecfullpctscorefixed ecfulldividedgov if pctchrealpcgenexpend>=-8.247863 & pctchrealpcgenexpend<=14.71839, fe cluster(state_code)

estat ic 

*

*
*
*



**** NOTE: BEN, TABLE SA-5 HAS ONLY TWO MODELS SO YOU WILL NEED TO ELIMINATE THE FINAL TWO COLUMNS/MODELS THAT PRESENTLY APPEAR IN THIS TABLE IN THE SUPPLEMENTARY APPENDIX DOCUMENT.


***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************

***************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************




***** CLOSE STATA OUTPUT LOG *****

log close





  

